﻿CREATE TABLE [dbo].[products] (
    [ID]                INT           IDENTITY (1, 1) NOT NULL,
    [ProductNo]         VARCHAR (20)  NULL,
    [ProductName]       VARCHAR (100) NOT NULL,
    [Pinyin]            VARCHAR (100) NULL,
    [UnitName]          VARCHAR (10)  NULL,
    [AssistantUnitName] VARCHAR (10)  NULL,
    [AssistantUnitRate] INT           NULL,
    [SortIndex]         INT           CONSTRAINT [DF_products_SortIndex] DEFAULT ((0)) NOT NULL,
    [Status]            INT           CONSTRAINT [DF_products_Status] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_products] PRIMARY KEY CLUSTERED ([ID] ASC)
);







